Gerrit Mantel
Programs SQL_STORED_PROCEDURE - prc_save_text_to_utf8file

Main program

Nameprc_save_text_to_utf8file
Type_descSQL_STORED_PROCEDURE
CommentSQLServer Stored Procedure

PURPOSE
Write text variable to utf-8 file with BOM.

OLE Automation Procedures has to be enabled.
Existing files will be overwritten.
If path does not exist, no error is raised. Check path before with function fun_FolderExist.
If file could not be created, no error is raised. Check file afterwards with function fun_FileExist.

Parameters
1 @text VARCHAR(MAX) = (nonbinary) text
2 @filename VARCHAR(265) = filespec

HISTORY
2025-10-12 - Created procedure

TAGS
<program>
<description>Write text variable to utf-8 file with BOM</description>
<generic>1</generic>
<author>Gerrit Mantel</author>
<created>2025-10-12</created>
<lastmodified>2025-10-12</lastmodified>
</program>
DescriptionWrite text variable to utf-8 file with BOM
Minversion
Generic1
AuthorGerrit Mantel
Created2025-10-12 00:00:00
Lastmodified2025-10-12 00:00:00
Xp_cmdshell0
Ole_automation1
Subprogram_cnt0
Sourcecode