Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Saving text in russian

  
   Database Help (Home) -> mySQL RSS
Next:  Regarding Identity column value retreival  
Author Message
Lüpher_Cypher

External


Since: Feb 18, 2005
Posts: 6



(Msg. 1) Posted: Mon Feb 21, 2005 2:40 am
Post subject: Saving text in russian
Archived from groups: mailing>database>mysql (more info?)
Hi,
I have a table with a field that is to save text in Russian. The text is
then retrieved by a PHP page. I run a query passing text in windows-1251
encoding, but when I retrieve it from the db, it shows up all wrong.
Does anyone know what the problem is?

Thanks,
Lüph

 >> Stay informed about: Saving text in russian 
Back to top
Login to vote
Lüpher_Cypher

External


Since: Feb 18, 2005
Posts: 6



(Msg. 2) Posted: Mon Feb 21, 2005 3:40 am
Post subject: Re: Saving text in russian [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Lüpher Cypher wrote:
 > Hi,
 > I have a table with a field that is to save text in Russian. The text is
 > then retrieved by a PHP page. I run a query passing text in windows-1251
 > encoding, but when I retrieve it from the db, it shows up all wrong.
 > Does anyone know what the problem is?
 >
 > Thanks,
 > Lüph

Nevermind that, I've decided to use Unicode, but here came another problem:

INSERT INTO tbl (name_ru) VALUES ("Админ");

will insert only "Адм".. Anyone? Smile

Lüph

 >> Stay informed about: Saving text in russian 
Back to top
Login to vote
Lüpher_Cypher

External


Since: Feb 18, 2005
Posts: 6



(Msg. 3) Posted: Mon Feb 21, 2005 3:40 am
Post subject: Re: Saving text in russian [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
 > Nevermind that, I've decided to use Unicode, but here came another
problem:
 >
 > INSERT INTO tbl (name_ru) VALUES ("Админ");
 >
 > will insert only "Адм".. Anyone? Smile

Argh, I must be too tired Smile Forget it, I have varchar(20) there Smile)
 >> Stay informed about: Saving text in russian 
Back to top
Login to vote
Lüpher_Cypher

External


Since: Feb 18, 2005
Posts: 6



(Msg. 4) Posted: Mon Feb 21, 2005 3:40 am
Post subject: Re: Saving text in russian [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Lüpher Cypher wrote:
  > > Nevermind that, I've decided to use Unicode, but here came another
 > problem:
 >
  >>
  >> INSERT INTO tbl (name_ru) VALUES ("Админ");
  >>
  >> will insert only "Адм".. Anyone? Smile
 >
 >
 > Argh, I must be too tired Smile Forget it, I have varchar(20) there Smile)

Actually, not that tired Smile name_ru is varchar(120) now, but still saves
only 3 chars, even if &, #, and ; are escaped.. Anyone? Smile

Lüph
 >> Stay informed about: Saving text in russian 
Back to top
Login to vote
Lüpher_Cypher

External


Since: Feb 18, 2005
Posts: 6



(Msg. 5) Posted: Mon Feb 21, 2005 3:40 am
Post subject: Re: Saving text in russian [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Lüpher Cypher wrote:
 > Lüpher Cypher wrote:
 >
   >> > Nevermind that, I've decided to use Unicode, but here came another
  >> problem:
  >>
   >>>
   >>> INSERT INTO tbl (name_ru) VALUES
   >>> ("Админ");
   >>>
   >>> will insert only "Адм".. Anyone? Smile
  >>
  >>
  >>
  >> Argh, I must be too tired Smile Forget it, I have varchar(20) there Smile)
 >
 >
 > Actually, not that tired Smile name_ru is varchar(120) now, but still saves
 > only 3 chars, even if &, #, and ; are escaped.. Anyone? Smile
 >
 > Lüph

Too tired Smile Renamed the wrong field.. Disregard this post..
 >> Stay informed about: Saving text in russian 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
help,a regular text file how to sql 2000 table code ? - help,a regular text file how to sql 2000 table code ? i have a text file as follow, line with ¡°|¡±and {LF}, 8|-000000186075919.|+000000000387820.|2008-03-31|20010423| 9|-000000000003919.|-000000000123620.|2008-03-31|20010123|..

Best way to issue hundreds of inserts/updates??? - Using mysql 4.0.23- What is the best way to execute several (hundreds of) inserts and updates? Rather than issuing tons of individual inserts and updates, can I send the strings to a text file and then have mysql do them all?? IE : query.txt insert..

MySQL freezes, brings XP machine to a grinding halt - I've been using MySQL for a while for fairly light database development on my XP machine. Currently, I am just starting a new project and have experienced some big problems with MySQL today both on my office machine and at home where running a particular...

login as user 'root' but do not have root privlages and my.. - Hi gang: I'm experiencing a problem with MySQL -- I updated MySQL from version 4.1.0 to 4.1.10 and now when I login as root it doesn't show all the databases I should have access to, nor it doesn't recognize me being logged in as root (via..

FLUSH TABLES hangs if table is locked - Using FLUSH TABLES via the C query API mysql_query() hangs if the table is locked already. That is to say, nothing prevents me from running a LOCK TABLES twice; it won't tell me "it's already locked, don't try to run a FLUSH". Anyone know ...
   Database Help (Home) -> mySQL All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]