Re: incorrect char() string for bigint column
Posted by: Anthony Linnett
Date: August 07, 2011 11:52PM

please find script to insert. I had simplified my first post to simplify diagnostics. the bigint BI is now referenced as SIGNPOST in this example. is this sufficient?

HEX(BIGINT) returns a array of ascii characters that represent the integer value, rather than the numeric value I am after. I believe CHAR is the correct operation as per the documentation.

as this column is part of the pk, I would prefer to not implement as binary array. perhaps a different character set is the solution.

appreciate any further advice.


USE wlanmobile;
CREATE TABLE IF NOT EXISTS SIGNPOSTMAP(
SIGNPOSTID SMALLINT(6) UNSIGNED NOT NULL,
SIGNPOSTTYPE TINYINT(3) UNSIGNED NOT NULL,
SIGNPOST BIGINT(20) UNSIGNED NOT NULL,
PRIMARY KEY (SIGNPOSTTYPE, SIGNPOST)
)
ENGINE = MYISAM
AVG_ROW_LENGTH = 12
CHARACTER SET latin1
COLLATE latin1_swedish_ci;



Edited 1 time(s). Last edit at 08/08/2011 12:08AM by Anthony Linnett.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: incorrect char() string for bigint column
776
August 07, 2011 11:52PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.