Hello.
I can't make guessing about Hebrew code page, but MySQL support of character sets was very helpful with my Russian cp1251 encoding. Because windows console supports input on my system only in cp866, while other applications - cp1251. So in mysql command line client I was able to dynamically convert characters from cp866 into cp1251 using character_set_xxx variables. Some client on Unixes have koi8-r encoding, while windows clients - cp1251. In this case MySQL character sets support is very helpful as well. Another point - my Fedora distribution uses utf8 encoding as system character set. And utf8 in MySQL helps a lot. More good examples could give people whose databases have data in different languages. Maxim Vexler <[EMAIL PROTECTED]> wrote: >Hello to each and every one of you. > >I'm wondering about the practical effect of character sets in mysql 4.0 & >4.1 as follows. > >What is it good for? Assuming I'm storing text data uin windows-hebrew >(1255) codepage, to be used by my php application. I can have my database & >table to be defined as 'latin1' and it all works just the same as if I would >define the table to have 'hebrew' characterset. >After all, up until the point of using Unicode for storing text data, all >strings are single byte ASCII encoded, and all the db does it to store this >data (assuming I'm not using any collation specific sorting and such...). >I'm a bit confused about the subject and would appreciate any discussion or >a link to some article(s) that would be able to sharpen this for me. > >Why not does mysql even has different charactersets? >Where does it comes into effect for me, as an application developer relaying >on mysql (or similar database software) for the storage of my data? > > -- 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]
