Graeme's Wiki : firebird and unicode

Graeme's Wiki

Navbar

H o m e
I n d e x
F r e e P a s c a l
t i O P F
f p G U I T o o l k i t

Options

E d i t P a g e

firebird and unicode

==Summary Information==
Here is a quick summary. For more information refer to the links shown below.

The database needs to be created with a default character set. eg: UTF-8
The client program must also connect to the database server using the same character set for unicode to work correctly.

===Collations===
<ul>
  <li>It handles //Sorting// and //String Comparisons//
  <li>There is no default, so every string field that will be used for sorting or comparisons need to have it's collation specified.
</ul>

===Character Sets===
<ul>
  <li>This tells firebird how to store strings.
  <li>How much space to allocated for strings or characters. CHAR and VARCHAR.
</ul>

==Handy Links==
Firebird character sets and collations.
http://www.destructor.de/firebird/charsets.htm

Firebird INTL Architecture (a bit outdated information)
http://www.jodelpeter.de/i18n/fbarch/selecting_charset_and_collation_in_firebird.html

Performing Case Insensitive Searches
http://www.destructor.de/firebird/caseinsensitivesearch.htm

Firebird Collation Charts
http://www.collation-charts.org/firebird20/

Type the code word, MONDAY here and then press to finish editing.

Summary Information

Here is a quick summary. For more information refer to the links shown below.

The database needs to be created with a default character set. eg: UTF-8
The client program must also connect to the database server using the same character set for unicode to work correctly.

Collations

It handles Sorting and String Comparisons
There is no default, so every string field that will be used for sorting or comparisons need to have it's collation specified.

Character Sets

This tells firebird how to store strings.
How much space to allocated for strings or characters. CHAR and VARCHAR.

Handy Links

Firebird character sets and collations.
http://www.destructor.de/firebird/charse...arsets.htm

Firebird INTL Architecture (a bit outdated information)
http://www.jodelpeter.de/i18n/fbarch/sel...ebird.html

Performing Case Insensitive Searches
http://www.destructor.de/firebird/casein...search.htm

Firebird Collation Charts
http://www.collation-charts.org/firebird...irebird20/