FYI, concerning my previous email, it's solved. I upgraded the JDBC
drivers to the last ones and now it recognizes the unsigned data types.
Great! :-)
David
On Thu, 25 Apr 2002, David Collados Polidura wrote:
> Hi, I have a table in a MySQL database where some fields are declared as
> "unsigned". Example:
>
> CREATE TABLE cities (
> City_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
> City_name VARCHAR(50) NOT NULL
> }
>
> My problem appears when inside a .xsql file (Oracle XDK), I try to do a
> select (I show just the key part of the file):
> <xsql:query>
> select City_id from cities
> </xsql:query>
>
> If inside the Database, City_id always has values from 0 to 65535
> (UNSIGNED SMALLINT) what is perfect, the resulting XML of that query will
> always show negative values if City_id is bigger than 32767 (so it ignores
> the "UNSIGNED").
>
> Have you seen something like this before? Do you kwno what I'm doing
> wrong or what can I do to retrieve the values unsigned?
>
> Thanks in advance,
>
> David
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
