Subject | Re: [firebird-support] Help On Unicode! |
---|---|
Author | Martijn Tonies |
Post date | 2004-05-10T12:53:12Z |
Sidenote...
CREATE TABLE plane
(without quotes)
and
Address VARCHAR(30)
All your SQL becomes case insensitive:
select ADRESS from Plane
Instead of
select "Address" from "plane"
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
> Can anybody give me some hints and samples to update Unicode text toDid you know that if you use:
> a Unicode table?
>
> I have difficulty to insert Unicode text to a Unicode table.
> It seemed IBConsole also wouldn't allow me to enter data to that
> table.
>
> My sample table is just like:
>
> CREATE TABLE "plane"
CREATE TABLE plane
(without quotes)
and
Address VARCHAR(30)
All your SQL becomes case insensitive:
select ADRESS from Plane
Instead of
select "Address" from "plane"
> (With regards,
> "NAME" VARCHAR(30) CHARACTER SET UNICODE_FSS default 'simon',
> "Address" VARCHAR(30) CHARACTER SET UNICODE_FSS,
> "QTY" INTEGER
> );
>
>
> It seems Firebird/Interbase doesn't have enough paragraphs on Unicode!
>
>
> Any kind help is appreciated!
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com