Subject | Unicode size |
---|---|
Author | Chad Z. Hower aka Kudzu |
Post date | 2004-12-13T20:49:59Z |
I have a DB that is unicode except a few fields like email, password, etc
that I have deemed can/should be ascii.
I had an email field varchar 100 that was unicode. I tried to index it, but
it said index was too big. So I reduced it to 80. Same. So then I tried ot
convert it to ASCII, 100. It tehn said "Field must be at least 300 chars".
Does FB use 3 chars for each Unicode char? What kind of encoding is that? I
has assumed it was using UTF 16 which would be 2 bytes, but 3?
that I have deemed can/should be ascii.
I had an email field varchar 100 that was unicode. I tried to index it, but
it said index was too big. So I reduced it to 80. Same. So then I tried ot
convert it to ASCII, 100. It tehn said "Field must be at least 300 chars".
Does FB use 3 chars for each Unicode char? What kind of encoding is that? I
has assumed it was using UTF 16 which would be 2 bytes, but 3?