Error: while saving encrypted string into MYSQL database on win2k8r2
Posted by: amar patil
Date: October 19, 2011 10:27PM

I have problem while store encrypted string in mysql database ...I am using win2k8r2 OS my problem is I want to insert following query throw C code

REPLACE INTO ss_users SET username='Administrator', password='º"¼4T☼Q,▲↓å$hê▲≥╥TcZ∩1';

After executing above query throw binary database shows empty filed for password.

Interesting thing is above query works fine if I run it manually in mysql database. I am confused in finding out whats the problem?

Guide me if there is any specific collection or type is present in mysql for encrypted string ...


here is DB schema :

CREATE TABLE IF NOT EXISTS `ss_users` (
`username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`type` int(255) NOT NULL COMMENT '0::Admin, 1 ::User',
`first_name` varchar(255) NOT NULL,
`last_name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



Edited 1 time(s). Last edit at 10/20/2011 12:27AM by amar patil.

Options: ReplyQuote


Subject
Views
Written By
Posted
Error: while saving encrypted string into MYSQL database on win2k8r2
1217
October 19, 2011 10:27PM


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.