Feedback:

Support a HEX field and/or HEX string operations

From customer:

Provide support for basic HEX: Most of my data is numeric strings: eg: "1234567890", 8>16 digits, stored as char/cichar, but there is a huge 'waste' in the ascii-encoding and subsequent indexing (ignoring unicode and char-mapping) and I have been unable to knock up my own 'hex encoding scheme' to work with hex via ascii codes. I feel that if there was a simple, low overhead, I/O routine based on the RAW data type and giving HEX I/O I could reduce my table data size by a 3rd and halve my index ADI size too! (and significantly decrease index build/search time) I hope I could use a simple "&H" type prefix in the string and use such a string directly in selects and inserts. Other DBs do support it (MS-SQL/DB2) after a fashion, but the only hex I can find in ADS is in the GUID/newID process. The Hex I/O mode would also help manage GUIDs into low-ovehead bytes to reduce replication overheads. (any HEX I/O must be available via ADO/ADO.NET, I am happy to I/O in ASCII/ANSI as long as ADS works with 'bytes' internally)*. Working with HEX would open up all sorts of cypto-graphic possibiliies and other encoding tasks.

2 votes
Vote 0 votes Vote Vote
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service

    You'll receive a confirmation email with a link to create a password (optional).

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    jeremym1234jeremym1234 shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service

      You'll receive a confirmation email with a link to create a password (optional).

      Signed in as (Sign out)
      Submitting...

      Knowledge Base and Helpdesk