Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

MSSQL truncate strings at 8000 chars #26

Open
bero opened this issue Dec 7, 2024 · 0 comments
Open

MSSQL truncate strings at 8000 chars #26

bero opened this issue Dec 7, 2024 · 0 comments
Assignees
@bero

Comments

@bero
Copy link
Member

bero commented Dec 7, 2024

Even when database column is longer than 8000 chars data is truncated.
@bero bero self-assigned this Dec 7, 2024
bero added a commit that referenced this issue Dec 7, 2024
@bero
Fix TBoldPMString.GetColumnBDEFieldType. #26.
8d36128 
Changed from ftWideString to ftWideMemo and ftString to ftMemo
as MSSQL truncates string params to 8000

This was already implemented before, but got lost at 15.3.2024
bero added a commit that referenced this issue Dec 7, 2024
@bero
Only using MSSQL woraround when
c7707b0 
SQLDatabaseConfig uses SQL Server engine. So other databases not having
that mssql-workaround in use #26
bero added a commit that referenced this issue Dec 7, 2024
@bero
Changed TBoldPMString.ValueToParam
c99ddf9 
We already had a workaround to avoid truncation of strings with
size >= 8000. But in case we are using Unicode, we need to check for
4000 chars, because when using Unicode each char requires twice as much
space #26
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@bero bero

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@bero