Subject | RE: Firebirdsql adding new charsets to database |
---|---|
Author | Svein Erling Tysvær |
Post date | 2014-09-16T07:48:09Z |
If your database has the right ODS version, i.e. that it is created with Firebird 2.5, then you can just use the character set – i.e.
CREATE TABLE MyTable(
MyChineseField Varchar(50) character set GB18030,
MyNorwegianField Varchar(50) character set iso8859_1 collate no_no,
MyASCIIField Varchar(50) character set ASCII);
I’ve never used it myself, but a quick search on the Internet indicates that FBClone possibly could help you change the character set of an existing database.
HTH,
Set
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 16. september 2014 00:07
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Firebirdsql adding new charsets to database
Dear Firebirdsql Community,
I want to add GB18030 charset to an existing firebirdsql database. How can I do that? Is that even doable, or will that require a new database to be created?
Firebird database engine version: 2.5.2
Thank you!
Regards,
Vardan Minasyan
Regards,
Vardan Minasyan
949-645-1019 x2
If you need to send us a file, follow the link below.
https://quickbooksconsultant.sharefile.com/r/r487ddfe0d9c490f8
[Non-text portions of this message have been removed]
CREATE TABLE MyTable(
MyChineseField Varchar(50) character set GB18030,
MyNorwegianField Varchar(50) character set iso8859_1 collate no_no,
MyASCIIField Varchar(50) character set ASCII);
I’ve never used it myself, but a quick search on the Internet indicates that FBClone possibly could help you change the character set of an existing database.
HTH,
Set
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 16. september 2014 00:07
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Firebirdsql adding new charsets to database
Dear Firebirdsql Community,
I want to add GB18030 charset to an existing firebirdsql database. How can I do that? Is that even doable, or will that require a new database to be created?
Firebird database engine version: 2.5.2
Thank you!
Regards,
Vardan Minasyan
Regards,
Vardan Minasyan
949-645-1019 x2
If you need to send us a file, follow the link below.
https://quickbooksconsultant.sharefile.com/r/r487ddfe0d9c490f8
[Non-text portions of this message have been removed]