Subject Create database with Jaybird...using charset?
Author bluenote
Post date 2004-01-12T18:45:53Z
Is there a way to set the charset for a newly created DB within a java app with a charset specified?
 
I use Tomcat and would like to ISO8859_1
 
FBManager does not seem to have the option. ( I even tried a url variable).
 
Also tried..
 
PreparedStatement ps = null; //and Statement
...
ps.execute( "CREATE DATABASE XYZ.FDB ...
 
SPL? I could not get it to cooperate in this respect.
 
 
If this is not usual practice is it accepted/usual/better to use 
...
new String(rs.getBytes(1),"encoding");   
 
for every varchar/char column?
 
or a blob?
 
 
I could make a 'dummy.fbd' file and copy it everytime.
 
I was looking for something a little more elegant.
 
Any platform or version. Any suggestions or Manual references appreciated.
 
Thanks