Hi Ruben, Please could you post your database connection again? So Shawn could add it to the manual: How to support foreign languages with AS400?
Thanks Henner > -----Urspr�ngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im > Auftrag von [EMAIL PROTECTED] > Gesendet: Dienstag, 25. Februar 2003 08:09 > An: Shawn > Cc: dbf > Betreff: Re: [dbforms] Support of Latvian language > > > > Hi, > > It's a miracle! Something from your suggestions was helpful! > Now the aplication works with latvian symbols, as if there > were no problems before... I don't know what exactly helped > to solve a problem. At this time application uses filter, > uses jdbc properties and in jsp pages there is a string <%@ > page contentType="text/html; charset=windows-1257" %>. All of > these methods helped to solve a problem. Thanks, Shawn!!! > > Ruben > ___________ > > > > > I hate it when my suggestions don't help. > > Next, let's try this from ch17 Connection Support of the manual. > > <dbconnection id = "jakarta-commons-dbcp" isJndi = "false" > isPow2 = "true" 89 default = "false" connectionProviderClass > = "org.dbforms.conprovider.JakartaConnectionProvider" > connectionPoolURL = "" conClass = "org.postgresql.Driver" > name = "jdbc:postgresql://localhost/myDatabase" username = > "postgres" password = ""> > > <!-- jdbc properties --> <property name="charSet" value="ISO-8859-1" > /> </dbconnection> > > This example was taken from the Jakarta Connections Pool but > I know Sybase users have to pass in properties to thier drive > this way and not in the name property. Maybe your driver is the same. > > Shawn > > On Mon, 2003-02-24 at 21:35, [EMAIL PROTECTED] wrote: > > I have tried these two methods. > > > > 1) Filter changed nothing: "?" are still displaying in > input elements. > > Non-english symbols are replaced with "?". If I don't use > text input > > elements, text is showing correctly. Even button labels can > be written > > in Latvian. And table fields are with Latvian symbols, if I display > > them > with > > help of construction: > > <td><%= currentRow_TableName.get("FieldName") %></td> > > > > 2)I'm using jt400.jar driver, than connects to AS/400 server. This > > driver do not support Unicode. And adding characterEncoding to line > > "jdbc:as400://lkb01;characterEncoding=windows-1257" doesn't change > > anything. Maybe somebody know how to set as400 driver to work > > correctly. I'm not sure that problem is in driver. As it reads > > information correctly when text input controls are not beeing used. > > Now I'm going to write pure jsp page which will get data with this > driver, > > without DbForms. This will be the way to check wether problem is in > DbForms > > or in driver. > > > > Of course, if you have any suggestions, please, write them > to me! If > > anyone have used DbForms with AS/400, please help to set up driver! > > Please write, if you had similar problem! > > > > Shawn, could you write about other ways to set drivers charset! > > > > With hope to solve a problem, > > Ruben > > > > > > > > Hi, > > > > I don't know why but using charset=**** never worked for me. > > > > Two things helped me though: > > > > 1) using the > > > Jakarta-tomcat-4.0/webapps/examples/WEB-INF/classes/filters/Se > tCharacterEncodingFilter.java > > > > > by setting in in web.xml and moving to WEB_INF/classes of my webapp > > > > and 2) making sure my driver was set properly > > > > <!dbconnection > > name = > > > "jdbc:mysql://localhost/test?useUnicode=true&characterEnco > ding=Shift_JIS" > > > > > > > Obviously I am using a diff charset than you but.... > > > > There are otherways to set your drivers charset if this > doesn't work > > for your db :) > > > > There are lots of people on this list using diff charsets > so I think > > you shouldn't have an unresolable problem. :) > > > Hi, > > > > > > I'm using DbForms in Latvia. And I have problem with Latvian > > > language support in dbforms. Can anyone help with this > problem??? I > > > use string <%@ page contentType="text/html; > charset=windows-1257" %> > in > > > the beginning of jsp. This string should set encoding to > Latvian. In > the > > > reality this string works only in cases when I don't use form > > > elements, such as <db:textField>. But when I use <db:textField>, > > > latvian symbols > in > > > this field are replaced with "?". Please, help me! > > > > > > Thanx in advance, > > > Ruben > > > > > > > > > > > > ------------------------------------------------------- > > > This SF.net email is sponsored by: SlickEdit Inc. Develop > an edge. > > > The most comprehensive and flexible code editor you can use. Code > > > faster. C/C++, C#, Java, HTML, XML, many more. FREE 30-Day Trial. > > > www.slickedit.com/sourceforge > > > _______________________________________________ > > > DbForms Mailing List > > > > > > http://www.wap-force.net/dbforms > > -- > > Shawn <[EMAIL PROTECTED]> > > > > > -- > Shawn <[EMAIL PROTECTED]> > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > DbForms Mailing List > http://www.wap-force.net/dbforms ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
