To my knowledge SQLite can only store text using UTF-8 or UTF-16 encoding.
I guess in some circumstances the latin1 representation would be more compact than UTF-8, but if that's an issue for you then you would probably want to apply some kind of external compression algorithm to your strings and then store them as blobs. Dan. --- C�cilia Vigny <[EMAIL PROTECTED]> wrote: > Hi, > > is it possible to specify the character set for a table ? I would like > my data to be in latin1 instead of utf-8. > > Thanks ! > > > Ce message est prot?g? par les r?gles relatives au secret des > correspondances. Il est donc > ?tabli ? destination exclusive de son destinataire. Celui-ci peut donc > contenir des informations > confidentielles. La divulgation de ces informations est ? ce titre > rigoureusement interdite. Si > vous avez re?u ce message par erreur, merci de le renvoyer ? l'exp?diteur > dont l'adresse e-mail > figure ci-dessus et de d?truire le message ainsi que toute pi?ce jointe. > > This message is protected by the secrecy of correspondence rules. Therefore, > this message is > intended solely for the attention of the addressee. This message may contain > privileged or > confidential information, as such the disclosure of these informations is > strictly forbidden. > If, by mistake, you have received this message, please return this message to > the addressser > whose e-mail address is written above and destroy this message and all files > attached. > > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
