poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Wu, William [IT]" <william...@citigroup.com>
Subject Weird character in excel
Date Mon, 15 Nov 2004 20:03:19 GMT
Hello,

I'm having problems storing a string into our Sybase database. The culprit is the '-' between
75 and 99; HEX value 13. It looks like a hyphen (HEX 2D) but it really isn't. Is there a way
to change the weird hyphen to the normal one? Below is a dump from biffview. When trying to
store the string in the database it comes up as 75 ? 99%.

Thanks in advance.

William


rectype = 0xfc, recsize = 0x39
-BEGIN DUMP---------------------------------
00000000 01 00 00 00 01 00 00 00 17 00 01 31 00 20 00 3D ...........1. .=
00000010 00 20 00 37 00 35 00 20 00 13 20 20 00 39 00 39 . .7.5. ..  .9.9
00000020 00 25 00 3B 00 20 00 32 00 20 00 3D 00 20 00 42 .%.;. .2. .=. .B
00000030 00 20 00 2D 00 20 00 41 00                      . .-. .A.
-END DUMP-----------------------------------
Offset 0x5f1 (1521)
recordid = 0xfc, size = 57
[SST]
    .numstrings     = 1
    .uniquestrings  = 1
    .string_0      = 1 = 75 - 99%; 2 = B - A
[/SST]

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


Mime
View raw message