Still does not translate

[pwatel]

Thanks for your solution but the
TCBatchmove gives me an error
"Cannot transliterate character between characters sets"

Which is what I want to go from NONE to UTF8
Any ideas
Regards
PW



Joined: 11 Feb 2009
Posts: 26


PostPosted: Mon Sep 21, 2009 8:39 am Post subject: Translate a non UTF Database into UTF8 Reply with quote Edit/Delete this post
Hi everyone,
Having switched from D6 to D2009 so now all string are unicode, I have a legacy Firebird DB in char set none given I have nearly completed the code changes and I would like to upgrade the database in full UTF8 for all string fields (we use a combination of Greek, French and English names.....)
I know how to rewrite the entire database with empty data in SQL
but what about data transfer

1) Do I have to write code with 2 connections and translate each records
via
DatasetUTF.insert
DatasetUTF[field1].asstring := Dataset[field1].asstring ;
DatasetUTF.post

2) or via
SQL insert
parameter('pname').aswidestring = Dataset[field1].asstring

3) Or any other methods backup/ restore

4) Or other unknown simpler methods ?????

I am sure others have been faced with the same issue.....
Thanks
Philippe Watel
Back to top
View user's profile Send private message Send e-mail
Plash
Devart Team


Joined: 10 May 2006
Posts: 2380


PostPosted: Tue Sep 22, 2009 8:25 am Post subject: Reply with quote
You can try to use the TCRBatchMove component to copy data.
Back to top
View user's profile Send private message Visit poster's website
pwatel



Joined: 11 Feb 2009
Posts: 26


PostPosted: Tue Sep 22, 2009 9:54 am Post subject: The mover does not move Reply with quote Edit/Delete this post Delete this post
Thanks for your solution but the
TCBatchmove gives me an error
"Cannot transliterate character between characters sets"

Which is what I want to go from NONE to UTF8
Any ideas
Regards
PW

[Plash]

Please see my reply in the old topic:
http://www.devart.com/forums/viewtopic. ... 9284#49284

[pwatel]

the stuff crashed because we have memo text fields
also with Greek alphabet when I enabled memos to true
It was not crashing anymore
I have to look if they were translated ok