Re: Generate Unique Identifier

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Laks <Laks@xxxxxxxxxxxxxxxxxxxxxxxxx>'s wild thoughts were
released on Thu, 3 Jan 2008 06:41:09 -0800 bearing the
following fruit:

Hi Jan

I am creating a Description column based on concatination of 4 columns in a
database like for e.g. (not the real life one though it is more complex)

Column 1 = 'This'
Column 2 = 'Is'
Column 3 = 'my'
Column 4 = 'table'

so the description column is 'This Is my table' and I need to generate an
Alphanumeric Code like I mentioned which is 6 Characters wide and on each
generation it must have the same unique identifier for this string.

The reason why I have these restrictions because this is a part of the huge
system and this needs to fit into it.

That doesn't really answer my question. I think it would be
difficult for anyone to help you without more detailed
information.

for example, is the first character is meant to represent
the first word? If so how many possible first words can
their be?

J

Regards
Laks
"Jan Hyde (VB MVP)" wrote:

Laks <Laks@xxxxxxxxxxxxxxxxxxxxxxxxx>'s wild thoughts were
released on Thu, 3 Jan 2008 03:46:01 -0800 bearing the
following fruit:

Hi

I want convert a String in a Database to a six digit Alphanumeric Code, 4
Characters and 2 Digits. The string can be of variable length of upto 50
Characters, but this string value is unique to the Table.
Example 'This is my Table', 'This may be your query' I want to convert this
into a 6 digit code like 'XSDH90' and 'GHJI24', can anyone please provide me
with the algorithm, I am okay with any language.

I'm not sure that it's possible. Why would you want to do
this?


--
Jan Hyde

https://mvp.support.microsoft.com/profile/Jan.Hyde


--
Jan Hyde

https://mvp.support.microsoft.com/profile/Jan.Hyde
.

Relevant Pages

  • Possible "bug" found in gnatcoll-sql_impl.adb
    ... I end up with more characters than I've bargained for. ... I end up with Peter in the database. ... extra single quotes added to all my string data. ...
    (comp.lang.ada)
  • Re: Reading Russian text in Word2003 VBA code
    ... Likely, your string contains the correct cyrillic string, but the control ... The VBA editor, immediate window or a MsgBox will display question marks ... for characters that aren't in the code page they are set up for. ... Whether the database can deal with Unicode, or the mechanism that you use ...
    (microsoft.public.word.vba.userforms)
  • Re: DB2 UTF-8 ODBC double conversion
    ... UTF-8 *is* Unicode. ... byte to store characters in the 7-bit ASCII code. ... If I give a UTF-8 string to CreateFile, ... this means that everyone who is using that database has to understand that the ...
    (microsoft.public.vc.mfc)
  • Re: Intermittent Character Encoding Issues
    ... It has been verified that the string is encoded ... regard a text string as being a set of Unicode characters, ... is stored in your mysql database is confusing perl, ... be converted from a sequence of characters into a sequence of octets, ...
    (comp.lang.perl.misc)
  • Re: seach for character
    ... bearing the following fruit: ... all I have to do is to type in a string of characters in one text box. ... do anyone have an idea or suggestion I would gladly like ...
    (microsoft.public.vb.syntax)