Hello.
> what do you really mean? I cannot have different symbols (hebrew,thai, > cyrillic) in same table!? I wouldn't say so. This project started when We have a lots of changes in MySQL 4.1. These are include the different character set support. In MySQL 4.1 during the work data might have a lot of transformations. See: http://dev.mysql.com/doc/refman/5.0/en/charset.html http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html The preferred way in my opinion is to use UTF8 if you have mix of different languages. Are you able to get a correct data in some way (through PHP for example)? Or every method you have tried produces a wrong data? mysqldump outputs the data in UTF8 by default, you can change the output encoding using --default-character-set option. See also about "SET NAMES" clause. gioklio wrote: > Let's go step by step: > > - database server is the same MySQL 4.1.5-gamma > - 'All charset variables are set to default 'latin1', except > 'character_set_system', which is utf8' is the same > - 'data it gets (from php) were in utf8' is the same > - 'Mysqldump is used without any options' is the same > - 'When importing back into the same database some characters (non > latin,cyrillic in fact) get broken' this not the 'same': I get many > other characters broken not only cyrillic. Users stores data in many > encodings: hebrew, thai, cyrillic, etc... > > When you say: > >>Delyan was using cyrillic symbols with latin1 encoding, which is not > designed for this purposes. > > what do you really mean? I cannot have different symbols (hebrew, thai, > cyrillic) in same table!? I wouldn't say so. This project started when > MySQL didn't have support for UTF-8 encoding and because of that all > tables are by default latin1. > >>4.1.5-gamma-log is a very old release > > So what? The server is the same one on which backup was made. > >>Check if the problem remains if you use mysqldump which is shipped with > 4.1.14 distribution > > Unfortunately I cannot do this. > > What do you suggest me as solution, how I can get my data back? I cannot > believe that is not possible to restore data the same way it was stored. > The fact is that utf8 data was stored in latin1 tables and I want that > data back in same way. > > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
