| View previous topic :: View next topic |
| Author |
Message |
mi-go
Newbie
Joined: 23 Dec 2011
Posts: 2
|
 Posted: Fri Dec 23, 2011 4:17 am Post subject: Export SCRIPT command using UTF-8 ? |
 |
|
Hi!
I have to use SCRIPT command to export a Base data base to a .sql file. But SCRIPT command export characters on ASCII format.
For example it change "í" character to "\u00ed".
Is there a way to use SCRIPT command to export to UTF-8 format?
Thanks! |
|
| Back to top |
|
 |
Sliderule
Super User
Joined: 29 May 2004
Posts: 2473
Location: 3rd Rock From The Sun
|
| Posted: Fri Dec 23, 2011 8:58 am Post subject: |
|
|
You said /asked:
| mi-go wrote: | For example it change "í" character to "\u00ed".
Is there a way to use SCRIPT command to export to UTF-8 format? |
Not to my knowledge.
You can read about the SCRIPT command at HSQL documentation at:
http://www.hsqldb.org/doc/guide/ch09.html#script-section
Solution: Now, if you have the file that it creates, I just did an internet search on the words: convert ascii "utf-8"
One web site I found would probably get the results you want:
http://rishida.net/tools/conversion/
With it, you can paste from your clipboard some text . . . and it will return a 'converted' version of the same. 
For example, I entered:
| Code: | For example it change "í" character to "\u00ed".
Is there a way to use SCRIPT command to export to UTF-8 format? |
pressed the Convert button, and, the following is returned:
| Code: | For example it change "í" character to "í".
Is there a way to use SCRIPT command to export to UTF-8 format?
|
I hope this helps, please be sure to let me / us know.
Sliderule
Thanks to add [Solved] in your first post Title ( edit button ) if your issue has been fixed / resolved. |
|
| Back to top |
|
|
mi-go
Newbie
Joined: 23 Dec 2011
Posts: 2
|
| Posted: Fri Dec 23, 2011 9:05 am Post subject: |
|
|
Thanks Sliderule,
but I have already think about that solution and also search the web about convert ascii to utf-8. But all I have found are webs like you say, that web is usefull for a short string, but I have a really big .sql file.
I haven't found a software that open a text file and search and replace all ascii code to utf-8. A lot of software change file type, but not search and replace codes. |
|
| Back to top |
|
|
Sliderule
Super User
Joined: 29 May 2004
Posts: 2473
Location: 3rd Rock From The Sun
|
| Posted: Fri Dec 23, 2011 10:14 am Post subject: |
|
|
mi-go:
OK, sorry that did not work.
The only thing I can suggest, is that you ask the HSQL people directly, at the link below.
Be sure you tell them the VERSION of HSQL you are using:
- If you are using an Embedded OpenOffice ( or LibreOffice ) database, the version would be: 1.8.0.10
- You can confirm this by creating a NEW Query
- copy and past the following:
| Code: | | call "org.hsqldb.Library.getDatabaseFullProductVersion"() |
On the toolbar, before running, be sure to press once, the SQL icon with a green checkmark
If you are using a version of HSQL other than the above, you can run the following SQL query to report back the version you are using.
| Code: | | SELECT DATABASE_VERSION( ) AS "HSQL Version" FROM "INFORMATION_SCHEMA"."TABLES" WHERE "TABLE_NAME" = 'TABLES' |
HSQL forum can be found at: http://sourceforge.net/projects/hsqldb/forums/forum/73674
I hope this helps, please be sure to let me / others know.
Sliderule
Thanks to add [Solved] in your first post Title ( edit button ) if your issue has been fixed / resolved. |
|
| Back to top |
|
|
|
