Re: database design question

"danjourno" <danjourno_at_hotmail.com> writes:

> thank you for that..
>
> you have answered alot of my questions regarding possible bad practices in
> implementing the second option.
> the only problem with the first option is that mysql (btw I am using mysql)
> does not support different character sets within the same column.
> for example, if I have a label in english and another label in chinese for
> that same phrase, then I will be trying to put two labels of different
> character sets in the one collumn. Mysql does support having a diferent
> charset per column within a table with version 4 but not multiple charsets
> in the one column.
>
> Maybe I should use a simmilar design to the first but add more tables for
> each new language?
>

Could you use some sort of raw or binary type to store the different character sets?

Tim

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!