| 80 |
|
interface |
| 81 |
|
|
| 82 |
|
uses |
| 83 |
< |
Classes, SysUtils, IBExternals, IBHeader, IB, FBActivityMonitor, FBClientAPI; |
| 83 |
> |
Classes, SysUtils, IBExternals, IBHeader, {$IFDEF WINDOWS} Windows, {$ENDIF} IB, FBActivityMonitor, FBClientAPI; |
| 84 |
|
|
| 85 |
|
type |
| 86 |
|
|
| 138 |
|
function GetAsVariant: Variant; |
| 139 |
|
function GetModified: boolean; virtual; |
| 140 |
|
function GetDateTimeStrLength(DateTimeFormat: TIBDateTimeFormats): integer; |
| 141 |
+ |
function GetSize: cardinal; virtual; abstract; |
| 142 |
|
procedure SetAsBoolean(AValue: boolean); virtual; |
| 143 |
|
procedure SetAsCurrency(Value: Currency); virtual; |
| 144 |
|
procedure SetAsInt64(Value: Int64); virtual; |
| 319 |
|
function GetScale: integer; override; |
| 320 |
|
function getCharSetID: cardinal; override; |
| 321 |
|
function GetIsNullable: boolean; override; |
| 322 |
< |
function GetSize: cardinal; |
| 322 |
> |
function GetSize: cardinal; override; |
| 323 |
|
function GetArrayMetaData: IArrayMetaData; |
| 324 |
|
function GetBlobMetaData: IBlobMetaData; |
| 325 |
|
function GetStatement: IStatement; |
| 1175 |
|
end; |
| 1176 |
|
end; |
| 1177 |
|
|
| 1178 |
+ |
{Copied from LazUTF8} |
| 1179 |
+ |
|
| 1180 |
+ |
function UTF8CodepointSizeFull(p: PAnsiChar): integer; |
| 1181 |
+ |
const TopBitSetMask = $8000; {%10000000} |
| 1182 |
+ |
Top2BitsSetMask = $C000; {%11000000} |
| 1183 |
+ |
Top3BitsSetMask = $E000; {%11100000} |
| 1184 |
+ |
Top4BitsSetMask = $F000; {%11110000} |
| 1185 |
+ |
Top5BitsSetMask = $F800; {%11111000} |
| 1186 |
+ |
begin |
| 1187 |
+ |
case p^ of |
| 1188 |
+ |
#0..#191: // %11000000 |
| 1189 |
+ |
// regular single byte character (#0 is a character, this is Pascal ;) |
| 1190 |
+ |
Result:=1; |
| 1191 |
+ |
#192..#223: // p^ and %11100000 = %11000000 |
| 1192 |
+ |
begin |
| 1193 |
+ |
// could be 2 byte character |
| 1194 |
+ |
if (ord(p[1]) and Top2BitsSetMask) = TopBitSetMask then |
| 1195 |
+ |
Result:=2 |
| 1196 |
+ |
else |
| 1197 |
+ |
Result:=1; |
| 1198 |
+ |
end; |
| 1199 |
+ |
#224..#239: // p^ and %11110000 = %11100000 |
| 1200 |
+ |
begin |
| 1201 |
+ |
// could be 3 byte character |
| 1202 |
+ |
if ((ord(p[1]) and Top2BitsSetMask) = TopBitSetMask) |
| 1203 |
+ |
and ((ord(p[2]) and Top2BitsSetMask) = TopBitSetMask) then |
| 1204 |
+ |
Result:=3 |
| 1205 |
+ |
else |
| 1206 |
+ |
Result:=1; |
| 1207 |
+ |
end; |
| 1208 |
+ |
#240..#247: // p^ and %11111000 = %11110000 |
| 1209 |
+ |
begin |
| 1210 |
+ |
// could be 4 byte character |
| 1211 |
+ |
if ((ord(p[1]) and Top2BitsSetMask) = TopBitSetMask) |
| 1212 |
+ |
and ((ord(p[2]) and Top2BitsSetMask) = TopBitSetMask) |
| 1213 |
+ |
and ((ord(p[3]) and Top2BitsSetMask) = TopBitSetMask) then |
| 1214 |
+ |
Result:=4 |
| 1215 |
+ |
else |
| 1216 |
+ |
Result:=1; |
| 1217 |
+ |
end; |
| 1218 |
+ |
else |
| 1219 |
+ |
Result:=1; |
| 1220 |
+ |
end; |
| 1221 |
+ |
end; |
| 1222 |
+ |
|
| 1223 |
+ |
{Returns the byte length of a UTF8 string with a fixed charwidth} |
| 1224 |
+ |
|
| 1225 |
+ |
function GetStrLen(p: PAnsiChar; CharWidth, MaxDataLength: cardinal): integer; |
| 1226 |
+ |
var i: integer; |
| 1227 |
+ |
cplen: integer; |
| 1228 |
+ |
begin |
| 1229 |
+ |
Result := 0; |
| 1230 |
+ |
for i := 1 to CharWidth do |
| 1231 |
+ |
begin |
| 1232 |
+ |
cplen := UTF8CodepointSizeFull(p); |
| 1233 |
+ |
Inc(p,cplen); |
| 1234 |
+ |
Inc(Result,cplen); |
| 1235 |
+ |
if Result >= MaxDataLength then |
| 1236 |
+ |
begin |
| 1237 |
+ |
Result := MaxDataLength; |
| 1238 |
+ |
Exit; |
| 1239 |
+ |
end; |
| 1240 |
+ |
end; |
| 1241 |
+ |
end; |
| 1242 |
|
|
| 1243 |
|
function TSQLDataItem.GetAsString: AnsiString; |
| 1244 |
|
var |
| 1262 |
|
begin |
| 1263 |
|
sz := SQLData; |
| 1264 |
|
if (SQLType = SQL_TEXT) then |
| 1265 |
< |
str_len := DataLength |
| 1265 |
> |
begin |
| 1266 |
> |
if GetCodePage = cp_utf8 then |
| 1267 |
> |
str_len := GetStrLen(PAnsiChar(sz),GetSize,DataLength) |
| 1268 |
> |
else |
| 1269 |
> |
str_len := DataLength |
| 1270 |
> |
end |
| 1271 |
|
else begin |
| 1272 |
< |
str_len := DecodeInteger(SQLData, 2); |
| 1272 |
> |
str_len := DecodeInteger(sz, 2); |
| 1273 |
|
Inc(sz, 2); |
| 1274 |
|
end; |
| 1275 |
|
SetString(rs, PAnsiChar(sz), str_len); |
| 1276 |
|
SetCodePage(rs,GetCodePage,false); |
| 1277 |
< |
if (SQLType = SQL_TEXT) and (GetCharSetID <> 1) then |
| 1208 |
< |
Result := TrimRight(rs) |
| 1209 |
< |
else |
| 1210 |
< |
Result := rs |
| 1277 |
> |
Result := rs; |
| 1278 |
|
end; |
| 1279 |
|
SQL_TYPE_DATE: |
| 1280 |
|
result := FormatDateTime(GetDateFormatStr(TimeOf(AsDateTime)<>0),AsDateTime); |
