Alexander Kozlovsky <[EMAIL PROTECTED]> wrote: > Many students like gives russian names to columns, > and such columns must be double-quoted. >
Have you actually tried this? SQLite is suppose to allow the use of column names containing non-roman characters without the use of double-quotes. The rule in SQLite is that a column name (or table name) can be any sequence of characters that does not include US-ASCII punctuation or control characters and does not begin with a digit. If you are seeing otherwise, then file a bug report. Note also that if you names do include punctuation, then you can enclose them in [...] instead of "..." and they will never be mistaken for literals. -- D. Richard Hipp <[EMAIL PROTECTED]>