Thursday, May 11, 2006, 09:36:17, Preston & Chrystie wrote:
> if your first statement after creating the database is:
> PRAGMA encoding = "UTF-16";
> then the error you get is slightly different:
sqlite>> ALTER TABLE test1 ADD straße VARCHAR(255);
> SQL error: malformed database schema - near
ot a
developer at that level :(
Thanks,
Andreas
-Original Message-
From: Clay Dowling [mailto:[EMAIL PROTECTED]
Sent: Mittwoch, 10. Mai 2006 18:42
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Possible bug with non-standard characters in column names
[EMAIL PROTECTED] said:
> CREAT
with non-standard characters in column names
[EMAIL PROTECTED] said:
> CREATE TABLE test1 (loader_id INTEGER PRIMARY KEY, loader_status
> VARCHAR(255)); ALTER TABLE test1 ADD name VARCHAR(255); ALTER TABLE
> test1 ADD straße VARCHAR(255); ALTER TABLE test1 ADD plz VARCHAR(255);
>
>
[EMAIL PROTECTED] said:
> CREATE TABLE test1 (loader_id INTEGER PRIMARY KEY, loader_status
> VARCHAR(255));
> ALTER TABLE test1 ADD name VARCHAR(255);
> ALTER TABLE test1 ADD straße VARCHAR(255);
> ALTER TABLE test1 ADD plz VARCHAR(255);
>
> Raises an SQL error: malformed database schema - near
Creating a table like this:
CREATE TABLE test1 (loader_id INTEGER PRIMARY KEY, loader_status VARCHAR(255));
ALTER TABLE test1 ADD name VARCHAR(255);
ALTER TABLE test1 ADD straße VARCHAR(255);
ALTER TABLE test1 ADD plz VARCHAR(255);
Raises an SQL error: malformed database schema - near "plz":
5 matches
Mail list logo
