Thread: UDK - DLLBind: Embedded database (SQLite,MySQL) v3.1.0.2

New version released, due to a lack of personal time, and there weren't anybody contacting me for a testing job, this version isn't fully tested and the example is just a very small view on what you will be able to do!

Check out inital thread post for Download!

even if I probably never use this, I want to say thanks for releasing it

Due to a request by Dan Cowell I updated the version and added the source codes, missed it before (I'm sorry for this).

New version 3.1.0.2 (more or less HotFix) is available in the initial post!

Best regards

hey man, great work.

BUT we found an huge issue! We used MySql to save a hash encrypted password, wich works fine. But the SELECT statement always crashes the whole thing.

We found out that you cannot SELECT a varchar that has more than 15 characters with MySql!! It works with SQLite though.


We really hope that you can fix it, because we write an online application that really needs a SQL Server.


Thanks in advance.

Originally Posted by DennyRocket

hey man, great work.

BUT we found an huge issue! We used MySql to save a hash encrypted password, wich works fine. But the SELECT statement always crashes the whole thing.

We found out that you cannot SELECT a varchar that has more than 15 characters with MySql!! It works with SQLite though.


We really hope that you can fix it, because we write an online application that really needs a SQL Server.


Thanks in advance.

Oh, that is strange....will investigate, thanks!

Hey, thanks for your fast reply. I just found another strange thing in the file DB_DataProvider.uc. At the end of the three methods Insert, Delete and Update you call the method Select(), wich causes problems too. I commented it out and now it works properly again. What is the purope of this line? :P


UPDATE:

The SELECT statement for SQLite doesn't throw an error, but it also just returns 16 chars at max. The hashed pw is stored in the db with all 32 characters.

Originally Posted by DennyRocket

Hey, thanks for your fast reply. I just found another strange thing in the file DB_DataProvider.uc. At the end of the three methods Insert, Delete and Update you call the method Select(), wich causes problems too. I commented it out and now it works properly again. What is the purope of this line? :P


UPDATE:

The SELECT statement for SQLite doesn't throw an error, but it also just returns 16 chars at max. The hashed pw is stored in the db with all 32 characters.

The Select() is only added to "update" your dataprovider after updating the database.
And the 16 out of 32 chars sounds like a Unicode/Non-Unicode mismatch. Whats your character set and collation?

Hi, we tested ucs2_general, utf8_general, and latin 1_swedish(for some weird reason^^) in MySql. None of them work.

It still keeps crashing when we try to SELECT a varchar that is longer than 15 chars.

Inserts via QueryDatabase work properly with MySql, but using the DataProvider with binding does not insert anything(it always tells us that our first column can not be null).



Edit:

Hi again, I just want to ask how the chances are that you can fix this within the next two weeks? Because a working database is really important to us and we maybe have to write our own alternative dllbind, but again, we would really like to use your existing stuff.

Originally Posted by DennyRocket

Hi, we testet ucs2_general, utf8_general, and latin 1_swedish(for some weird reason^^) in MySql. None of them works.

It still keeps crashing when we try to SELECT a varchar that is longer than 15 chars.

Inserts via QueryDatabase work properly with MySql, but using the DataProvider with binding does not insert anything(it always tells us that our first column can not be null).



Edit:

Hi again, I just want to ask how the chances are that you can fix this within the next two weeks? Because a working database is really important to us and we maybe have to write our own alternative dllbind, but again, we would really like to use your existing stuff.

Don't worry, will deal with it this week

Hey man, I just wanted to let you know that we developed our own, small scale, MySQL interface. So there is no need to hurry

I have also a crash issue when i do a getStringVal from what i selected from the database ,


my log is recovering the right data but my game is crashing after that , is there a way to debug this ?