Windows Phone 8.1 SQLITE leading zeros disappears

Question

0.00/5 (No votes)

See more:

I have a Windows Phone 8.1 application. I have a Text type column in the database. When I insert data into the column, and the data contains a leading zero (Fe.: 02343) then db engine stores it without zero (2343). The insertation is from a List<mytype> object by SqlLiteConnection.InsertOrReplace(object obj) method. I check the source list<> it contains the 0 char. What should I do to store leading zero too?

Posted 6-Oct-15 23:29pm

DeveloperEU

Updated 7-Oct-15 2:05am

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kornfeld Eliyahu Peter · Answer 1 · 2015-10-07T02:12:00

Solution 1

If 02343 is a number the leading zero is only for display (a formatting) and has no meaning as 0123 is the exactly same thing as 123 - in numbers...So SQL will save it as number and fo that the leading zero will be gone...If you want the numbers to be displayed wiht leading zero in your application you have to the right formatting everywhere in your application...

Posted 7-Oct-15 2:12am

Kornfeld Eliyahu Peter

Comments

Kornfeld Eliyahu Peter 7-Oct-15 14:48pm

To a string representation of a number to lost its leading zeros somewhere in the process it must be converted (casted) to numeric type...You have to check the code for the insert to see...You may post that part to see if someone spots the problem...

DeveloperEU 8-Oct-15 2:44am

The problem is in sqlite.cs somewhere. I follow the code to the last debugable line in SQLite.cs. It was the SQLite3.BindText(...) function where the property has the right value yet. The later operations runs in sqlite3.dll.