OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Export SCRIPT command using UTF-8 ?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
mi-go
Newbie
Newbie


Joined: 23 Dec 2011
Posts: 2

PostPosted: Fri Dec 23, 2011 4:17 am    Post subject: Export SCRIPT command using UTF-8 ? Reply with quote

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
View user's profile Send private message
Sliderule
Super User
Super User


Joined: 29 May 2004
Posts: 2499
Location: 3rd Rock From The Sun

PostPosted: Fri Dec 23, 2011 8:58 am    Post subject: Reply with quote

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. Smile

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
View user's profile Send private message
mi-go
Newbie
Newbie


Joined: 23 Dec 2011
Posts: 2

PostPosted: Fri Dec 23, 2011 9:05 am    Post subject: Reply with quote

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
View user's profile Send private message
Sliderule
Super User
Super User


Joined: 29 May 2004
Posts: 2499
Location: 3rd Rock From The Sun

PostPosted: Fri Dec 23, 2011 10:14 am    Post subject: Reply with quote

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:

  1. If you are using an Embedded OpenOffice ( or LibreOffice ) database, the version would be: 1.8.0.10

    1. You can confirm this by creating a NEW Query
    2. copy and past the following:

      Code:
      call "org.hsqldb.Library.getDatabaseFullProductVersion"()

    3. On the toolbar, before running, be sure to press once, the SQL icon with a green checkmark

  2. 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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group