Subject | fb2.1 localized utf8 |
---|---|
Author | tjelvare |
Post date | 2008-10-26T21:03:14Z |
Hello world.
I would really appriciate some help in understanding setting up utf8/icu to work with
swedish collations,
what i what is the utf8-charset working case_insensitive, placing åäö after z:
so order by.... (ci_ordering required - without upper / computed field)
Adam,greger,Harald,zaphod,Åke,ärling,Örjan
I've tried intl.sql -> 2 sp's and fine, but then again that shouldn't be used for 2.1, right?
When i try (from the docs/intl.txt):
CREATE COLLATION UNICODE_ENUS_CI
FOR UTF8
FROM UNICODE
CASE INSENSITIVE
'LOCALE=en_US';
I get:
SQL Message : -607
This operation is not defined for system tables.
How to proceed?
Running: FB2.1 (win32),
database ODS:11.1, dialect:3, charset:utf8
all the best
//t eriksson
I would really appriciate some help in understanding setting up utf8/icu to work with
swedish collations,
what i what is the utf8-charset working case_insensitive, placing åäö after z:
so order by.... (ci_ordering required - without upper / computed field)
Adam,greger,Harald,zaphod,Åke,ärling,Örjan
I've tried intl.sql -> 2 sp's and fine, but then again that shouldn't be used for 2.1, right?
When i try (from the docs/intl.txt):
CREATE COLLATION UNICODE_ENUS_CI
FOR UTF8
FROM UNICODE
CASE INSENSITIVE
'LOCALE=en_US';
I get:
SQL Message : -607
This operation is not defined for system tables.
How to proceed?
Running: FB2.1 (win32),
database ODS:11.1, dialect:3, charset:utf8
all the best
//t eriksson