Re: incorrect char() string for bigint column
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.
Subject
Views
Written By
Posted
1264
August 07, 2011 06:58PM
665
August 07, 2011 07:36PM
765
August 07, 2011 10:09PM
626
August 07, 2011 10:21PM
679
August 07, 2011 11:31PM
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.