Subject | SQL dialect? |
---|---|
Author | Jacob Havkrog |
Post date | 2010-01-27T21:11:46Z |
Hi - I'm in the process of migrating a Delphi 2007 BDE application (recently migrated from Delphi 1!) with approx 250 forms and 88 Paradox tables to Firebird using IBObjects.
I'm still trying to figure out the best strategy. I've read the migration guide in the IBO help files carefully, but It's not always clear, what information is still relevant for the current version of IBO (4.9.9) and Firebird (2.1.3). Also, I've bought the Firebird Book by Helen Borrie.
A have a few questions:
What SQL dialect do you recommend? Is there any reason not to use dialect 3?
My application language is Danish, and I need in-case-sensitive sorting on database queries. Do I need Unicode for that? As a default database character set, or table char set? The Danish character set is the basic a-z with 3 additional letters æ, ø, å.
My application is not Unicode-ready in general, I haven't paid attention to that yet. Do I need to deal with that now?
Thanks for your help
Jacob Havkrog
[Non-text portions of this message have been removed]
I'm still trying to figure out the best strategy. I've read the migration guide in the IBO help files carefully, but It's not always clear, what information is still relevant for the current version of IBO (4.9.9) and Firebird (2.1.3). Also, I've bought the Firebird Book by Helen Borrie.
A have a few questions:
What SQL dialect do you recommend? Is there any reason not to use dialect 3?
My application language is Danish, and I need in-case-sensitive sorting on database queries. Do I need Unicode for that? As a default database character set, or table char set? The Danish character set is the basic a-z with 3 additional letters æ, ø, å.
My application is not Unicode-ready in general, I haven't paid attention to that yet. Do I need to deal with that now?
Thanks for your help
Jacob Havkrog
[Non-text portions of this message have been removed]