MySQL Forums
Forum List  »  Newbie

Need help with Stored Table Data
Posted by: T CV
Date: September 26, 2012 04:21PM

Hi There,

I'm a bit new to SQL etc, but have a grasp of what 'tables' are, how to connect to a DB, etc.

My question (or maybe questions)

1. I have a custom application that stores client data in a SQL database and tables. This application was bought as part of a business and is used as a client database.

Unfortunately, this 'developer' refuses to release certain parts of the information as an export (i.e. they wont extract email, or phone numbers for us, only address and name)

2. I have access to the SQL database and have found table that stores this information, but it appears like it is stored as some kind of 'secure' format (its data type in SQL is Varchar or Varbinary (256).

3. Is there some way in SQL to convert that data to something 'readable' ? Via some kind of query?

I can provide sample data if need be

(some of the data looks as follows when extracted to a CSV file)

Emails are stored like this: 59FF56A7A9180704C4FF42A2CFA27918E1A7564D9DD8BC539A3F88635F31608D

Phone Numbers:
(There are two fields)
PhnNmr: NULL
PhnNmrSec: 0x01000000411D43CE013EA8ADA8B6B7B69DD3C49A33683765AA7CCE2E059373BB9CACFDAFFDF0905520F4273486F179B17A725B3CEA0AA1737A304EBA

(i'm guessing that Sec is some kind of key)

I'm sorry if i'm asking too much, but i really need to try and extract this data somehow, and the developer is proving very difficult ;(

Is there a query I can do in SQL, to convert that data? Or am i truly limited by the what the developer and their front end application will allow ? :(

Options: ReplyQuote


Subject
Written By
Posted
Need help with Stored Table Data
September 26, 2012 04:21PM


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.