Select returns negative values for unsigned datatypes using XSQL

2002-04-25 Thread David Collados Polidura
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

Re: Select returns negative values for unsigned datatypes using XSQL

2002-04-25 Thread David Collados Polidura
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