Re: Ruby on rails' SQLite database with Chinese characters
"Henry" <liu_henry5@hotmail.com> writes:
> I installed a Debian Lenny AMD 64. I am planning to use Ruby in Rails
> to build some Chinese web pages. Now the Chinese input and output on
> Debian works just fine. I know in Ruby on Rails, I can add Chinese
> characters without problem.
> My question here is that whether the sqlite support Chinese
> characters.
Yes, by supporting UTF-8/16.
> If it does, do I need to use different data type other than string or
> text?
No, just set the character encoding (e.g., UTF-8) for your database,
then feed the database with that encoding.
> Any document out there? I searched and could not find any.
http://www.sqlite.org/pragma.html#pragma_encoding
> Thanks in advance.
>
> Henry
Reply to: