Subject Re: [firebird-support] Help On Unicode!
Author Martijn Tonies
Sidenote...


> Can anybody give me some hints and samples to update Unicode text to
> 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"

Did you know that if you use:
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"

> (
> "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!

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com