Subject | UNICODE_FSS as default charset ? |
---|---|
Author | Frederic |
Post date | 2002-09-26T09:04:37Z |
Hi,
I must say that I'm confused, in the newsgroup I read about users using
Unicode and in the Interbase 6 Developer's Guide (pdf) page 68 they
wrote the following:
"PreparedStatement setUnicodeStream() InterClient does not support UNICODE."
I'll use Firebird 1.0 on Redhat Linux 7.3(deployment) and Windows 2000
SP2(development).
I'm developing a multi-lingual web application, my client is HTML with
selection from several charsets for a same language code.
In the database I'll have to store data in Hebrew and Latin languages in
separate
database columns.
1) Should I select UNICODE_FSS as the default charset for the whole
database or would you advice to use the ISO8859_1 charset as the default
and the UNICODE_FSS charset for those columns only?
Disk capacity is not a problem, speed is. (I'll double the column length
for Unicode)
2) Which version of interclient does support Unicode and where can I
download it?
3) When I define my connection is it enough to add the following:
properties.put("charSet", "UTF8");
or do I need some additional coding for retrieve/store data in Unicode?
4) Is there a tool for inserting manually (with sql insert) unicode data
in the database?
Your help will be appreciated.
Frederic
I must say that I'm confused, in the newsgroup I read about users using
Unicode and in the Interbase 6 Developer's Guide (pdf) page 68 they
wrote the following:
"PreparedStatement setUnicodeStream() InterClient does not support UNICODE."
I'll use Firebird 1.0 on Redhat Linux 7.3(deployment) and Windows 2000
SP2(development).
I'm developing a multi-lingual web application, my client is HTML with
selection from several charsets for a same language code.
In the database I'll have to store data in Hebrew and Latin languages in
separate
database columns.
1) Should I select UNICODE_FSS as the default charset for the whole
database or would you advice to use the ISO8859_1 charset as the default
and the UNICODE_FSS charset for those columns only?
Disk capacity is not a problem, speed is. (I'll double the column length
for Unicode)
2) Which version of interclient does support Unicode and where can I
download it?
3) When I define my connection is it enough to add the following:
properties.put("charSet", "UTF8");
or do I need some additional coding for retrieve/store data in Unicode?
4) Is there a tool for inserting manually (with sql insert) unicode data
in the database?
Your help will be appreciated.
Frederic