• Welcome, Guest. Please login.
 
May 11, 2021, 07:28:57 PM

News:

Welcome to the SQLitening support forums!


Seemed data lost in remote mode?

Started by cyberazor, February 21, 2014, 05:24:45 AM

Previous topic - Next topic

cyberazor


cj

March 10, 2014, 02:38:53 AM #46 Last Edit: March 10, 2014, 02:49:02 AM by cj
Link to SQLite3.dll   version 3.8.3.1 which I am using.
Lots of fixes and new features since the SQLite3.dll that came with SQLitening.
Partial indexes and tables without rowids are supported.

http://www.sqlite.org/withoutrowid.html



It is worth a shot.  SQLite3.dll is 643,948 bytes.

http://www.sqlite.org/2014/sqlite-dll-win32-x86-3080301.zip


cyberazor

March 10, 2014, 04:23:22 AM #47 Last Edit: March 10, 2014, 04:32:19 AM by cyberazor
I thought the only difference among our computers is system locale, so I changed it from Chinese to English on server-side in control panel.

Now it works. I've learned a lot besides the question. Thank you cj! Thank you all!

cj


cj

March 10, 2014, 01:17:07 PM #49 Last Edit: March 10, 2014, 05:04:13 PM by cj
We might do a call to see what country the code is running in.
Not sure exactly where to go with this, but here is a start.

'#INCLUDE "win32api.inc"
'%CTRY_PRCHINA  = 86  ' People's Republic of China

'DECLARE FUNCTION SetLocaleInfoA LIB "KERNEL32.DLL" ALIAS "SetLocaleInfoA" _
'    (BYVAL Locale AS DWORD, BYVAL LCType AS LONG, lpLCData AS ASCIIZ) AS LONG

'DECLARE FUNCTION SetLocaleInfoW LIB "KERNEL32.DLL" ALIAS "SetLocaleInfoW" _
'    (BYVAL Locale AS DWORD, BYVAL LCType AS LONG, lpLCData AS WSTRINGZ) AS LONG
'#IF %DEF(%UNICODE)
'MACRO SetLocaleInfo=SetLocaleInfoW
'#ELSE
'MACRO SetLocaleInfo=SetLocaleInfoA
'#ENDIF ' NOT %UNICODE

FUNCTION PBMAIN() AS LONG
  ? GetCountry
END FUNCTION

FUNCTION GetCountry AS STRING
  LOCAL zBuffer AS ASCIIZ * 128, s AS STRING
  GetLocaleInfo %LOCALE_USER_DEFAULT, %LOCALE_SNATIVECTRYNAME,zBuffer, 128       'native country
  FUNCTION = REMOVE$(zBuffer,$NUL)
END FUNCTION










D. Wilson

Hats off to CJ for sticking it out and helping solve this issue.

cyberazor

Setting locale may affect other softwares, please take it into consideration.

For example, Total Commander cannot display Chinese correctly on its menu after changing of locale.