hi, to test it, just add a new user to the database, and in the form for
create a user you can change the default language, just select spanish

look at this image
http://www.opencrx.org/opencrx/1.10/MSSQL/openCRX_Installation_MSSQL_2005_html_491e9439.gif

select spanish, and add a insert trigger with

 RAISERROR 30004 'failed'

or you can use a trigger with non-ascci chars to fail inclusive for english
language users

 RAISERROR 30004 'fracasó'

best regards.

On 5/22/08, johnf <[EMAIL PROTECTED]> wrote:
>
> On Thursday 22 May 2008 08:40:10 am Jorge Mota wrote:
> > Hi again :)
> > I am testing the triggers of my app, I have have sql server in spanish.
> and
> > when a trigger get fired dabo alert me at
> >
> > class DBQueryException(DatabaseException):
> >  def __init__(self, err, sql):
> >   self.sql = sql
> >   self.err_desc = str(err)
> >
> > the error is
> >   File
> > "c:\python25\lib\site-packages\Dabo-0.8.3-py2.5.egg\dabo\dException.py",
> > line 78, in __str__
> >     return self.err_desc + '\nSQL: ' + self.sql
> > UnicodeDecodeError: 'ascii' codec can't decode byte 0xa2 in position 79:
> > ordinal
> >  not in range(128)
> >
> > because the odbc error have 'ó´ int he message:
> > internal error: SQL Server message 2627, severity 14, state 1, line 1:
> > Infracción de la restricción PRIMARY KEY 'PK_tbl_actividad'. No se puede
> > insertar una clave duplicada en el objeto 'tbl_actividad'.
> > SQL Server message 3621, severity 0, state 0, line 1:
> > Se terminó la instrucción.
> > DB-Lib error message 10007, severity 5:
> > General SQL Server error: Check messages from the SQL Server.
> >
> > best regards.
> >
> >
>
> You can't attach a file to list messages.  But you can open a ticket and
> attach files.
>
> Tell me more about what you do to setup your computer to accept non-english
> char's.  I would like to test on my system.
>
> Dabo I believe will accept non-ascii char's by adding '_()' to the string.
> I.e.  _("Select * from sometable").  I'm not completely sure about what I'm
> saying since I have never had need to use non-ascii char's.
>
> Maybe Uwe Grauer can help in this matter????
>
>
> --
> John Fabiani
>
>
[excessive quoting removed by server]

_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]

Reply via email to