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? Thank you very much, Maxim Vexler. -- Cheers, Maxim Vexler (hq4ever). Do u GNU ?