Hi,
I have nvarchar column which i use to save Arabic strings. When i save text from datawindow it saves as '?????? ???? ??????? 125?*15'.
But from backend its saves fine and works.
Any solutions?
Tool Using PowerBuilder 2022 R2, MS SQL server 2014
- You are here:
-
Home
-
Q&A
-
Q&A
-
PowerBuilder
- Arabic charater not saving through datawindow
-
Parvejali Chodhary
- PowerBuilder
- Monday, 9 September 2024 05:10 AM UTC
Thank you for replying.
Yes I need to save and update Arabic text to the database.
From where i can get this n_dwr_string.
//
// Function: of_GlobalReplace
//
// Access: public
//
// Arguments:
// as_Source The string being searched.
// as_Old The old string being replaced.
// as_New The new string.
// ab_IgnoreCase A boolean stating to ignore case sensitivity.
//
// Returns: string
// as_Source with all occurrences of as_Old replaced with as_New.
// If any argument's value is NULL, function returns NULL.
//
// Description: Replace all occurrences of one string inside another with
// a new string.
//
//////////////////////////////////////////////////////////////////////////////
//
// Revision History
//
// Version
// 5.0 Initial version
//
//////////////////////////////////////////////////////////////////////////////
//
// Copyright © 1996-1997 Sybase, Inc. and its subsidiaries. All rights reserved.
// Any distribution of the PowerBuilder Foundation Classes ( PFC )
// source code by other than Sybase, Inc. and its subsidiaries is prohibited.
//
//////////////////////////////////////////////////////////////////////////////
Long ll_Start, ll_OldLen, ll_NewLen
String ls_Source
//Check parameters
If IsNull ( as_source ) or IsNull ( as_old ) or IsNull ( as_new ) or IsNull ( ab_ignorecase ) Then
string ls_null
SetNull ( ls_null )
Return ls_null
End If
//Get the string lenghts
ll_OldLen = Len ( as_Old )
ll_NewLen = Len ( as_New )
//Should function respect case.
If ab_ignorecase Then
as_old = Lower ( as_old )
ls_source = Lower ( as_source )
Else
ls_source = as_source
End If
//Search for the first occurrence of as_Old
ll_Start = Pos ( ls_Source, as_Old )
Do While ll_Start > 0
// replace as_Old with as_New
as_Source = Replace ( as_Source, ll_Start, ll_OldLen, as_New )
//Should function respect case.
If ab_ignorecase Then
ls_source = Lower ( as_source )
Else
ls_source = as_source
End If
// find the next occurrence of as_Old
ll_Start = Pos ( ls_Source, as_Old, ( ll_Start + ll_NewLen ) )
Loop
Return as_Source
You can use the above function to replace values.