B BasilioObispo Member May 5, 2020 #1 I have an app developed for my church, but I need it in Greek, I use SQlite as DB but don't support Greek, when I try to put info in Greek show only ????????????, can you recommend me another DB (free) that support the language that I need. THANKS
I have an app developed for my church, but I need it in Greek, I use SQlite as DB but don't support Greek, when I try to put info in Greek show only ????????????, can you recommend me another DB (free) that support the language that I need. THANKS
Erel B4X founder Staff member Licensed User Longtime User May 5, 2020 #2 SQLite supports all languages. You did a mistake somewhere. Probably when you read data from a file or website. Upvote 0
SQLite supports all languages. You did a mistake somewhere. Probably when you read data from a file or website.
B BasilioObispo Member May 5, 2020 #3 Erel said: SQLite supports all languages. You did a mistake somewhere. Probably when you read data from a file or website. Click to expand... Erel, thanks for your answer, but, I have an .csv with all the info in greek and when I copy to de db only shows me ????? in the fields, I check the languages in SQlite and don't show greek. My app is ready but I need to present in greek to my superiors. Upvote 0
Erel said: SQLite supports all languages. You did a mistake somewhere. Probably when you read data from a file or website. Click to expand... Erel, thanks for your answer, but, I have an .csv with all the info in greek and when I copy to de db only shows me ????? in the fields, I check the languages in SQlite and don't show greek. My app is ready but I need to present in greek to my superiors.
klaus Expert Licensed User Longtime User May 5, 2020 #4 I'm afraid that your .csv file is encoded with Windows-1253 and not UTF-8. Try to convert it with notepad++. Upvote 0
I'm afraid that your .csv file is encoded with Windows-1253 and not UTF-8. Try to convert it with notepad++.
B BasilioObispo Member May 5, 2020 #5 Erel said: SQLite supports all languages. You did a mistake somewhere. Probably when you read data from a file or website. Click to expand... My excuses EREL, you are ok and I'm wrong. It's the csv that convert all characters from greek to ??????. So please tell me how can I pass directly from xls to the db Upvote 0
Erel said: SQLite supports all languages. You did a mistake somewhere. Probably when you read data from a file or website. Click to expand... My excuses EREL, you are ok and I'm wrong. It's the csv that convert all characters from greek to ??????. So please tell me how can I pass directly from xls to the db
B BasilioObispo Member May 5, 2020 #6 klaus said: I'm afraid that your .csv file is encoded with Windows-1253 and not UTF-8. Try to convert it with notepad++. Click to expand... Thanks for your answer, I have all ok in the xls file, but if I try to convert to csv something happens and change all the characters to ??????, same if I try to open with notepad Upvote 0
klaus said: I'm afraid that your .csv file is encoded with Windows-1253 and not UTF-8. Try to convert it with notepad++. Click to expand... Thanks for your answer, I have all ok in the xls file, but if I try to convert to csv something happens and change all the characters to ??????, same if I try to open with notepad
Erel B4X founder Staff member Licensed User Longtime User May 6, 2020 #7 Upload the CSV file. Upvote 0
DonManfred Expert Licensed User Longtime User May 6, 2020 #8 BasilioObispo said: same if I try to open with notepad Click to expand... never use notepad. Use Notpad++ Upvote 0
BasilioObispo said: same if I try to open with notepad Click to expand... never use notepad. Use Notpad++
B BasilioObispo Member May 6, 2020 #10 Erel said: Upload the CSV file. Click to expand... Thanks EREL, I found an Addin for Excel and solve the problem Upvote 0
Erel said: Upload the CSV file. Click to expand... Thanks EREL, I found an Addin for Excel and solve the problem
DMW Member Licensed User Longtime User May 6, 2020 #11 Could you, just for the record, tell us which Excel add-in you refer to. Upvote 0
arge06 Member Licensed User Longtime User May 10, 2020 #12 I wrote a .NET web application for use ,n my apps. DB and App is in my website. I'm sending data with url, it writes into table and also reading data with url parameters and data is written to page. But I don't know how to read page. You can use this way I think. Read : http://localhost:5232/Page1.aspx?ID=001A Write : http://localhost:5232/Page2.aspx?VALUE=20&ID=001A Upvote 0
I wrote a .NET web application for use ,n my apps. DB and App is in my website. I'm sending data with url, it writes into table and also reading data with url parameters and data is written to page. But I don't know how to read page. You can use this way I think. Read : http://localhost:5232/Page1.aspx?ID=001A Write : http://localhost:5232/Page2.aspx?VALUE=20&ID=001A