- 0
[SQL] Varchar cutting off my string!
-
Recently Browsing 0 members
- No registered users viewing this page.
-
Posts
-
-
By David Uzondu · Posted
LibreOffice narrows gap with Microsoft Office in 25.8 Beta 1 by David Uzondu The Document Foundation has released LibreOffice 25.8 Beta 1 for public testing on Linux, macOS, and Windows. This is the second pre-release for the 25.8 cycle and the foundation says that the final, stable version of LibreOffice 25.8 is expected to land at the end of August 2025. Starting off with Writer, LibreOffice's Word, the developers have finally addressed some long-standing annoyances, including a new command to easily insert a paragraph break right before a table. This beta also introduces a useful privacy feature in its Auto-Redact tool, letting you strip all images from a document with a single option. To use it, go to Tools and select the Auto-Redact option: The application has improved its ability to handle different languages for punctuation, preventing mix-ups in multilingual documents. Other notable improvements have also been made. A new hyphenation rule lets you choose to prevent a word from splitting at the end of a page, moving the whole line to the next page instead. Microsoft Word has had this feature for years now. The Navigator now displays a handy tooltip with word and character counts for headings and their sub-outlines. Scrolling behavior when selecting text has been improved, making it less erratic. A new command with a keyboard shortcut was added for converting fields into plain text. Calc gets a lot of new functions that bring it closer to its competitors like Excel, including TEXTSPLIT, VSTACK, and WRAPROWS. Impress now properly supports embedded fonts in PPTX files, which should reduce headaches when sharing presentations with PowerPoint users. Alongside these additions, the project is also cleaning house; support for Windows 7, 8, and 8.1 has been completely dropped. There are also smaller UI tweaks across the suite, like allowing a single click to enter rotation mode for objects in Writer and Calc. macOS users get better integration, with proper support for native full screen mode and new window management features from the Sequoia update. In terms of performance, the team has optimized everything from loading huge DOC files and XLSX spreadsheets with tons of conditional formatting to simply switching between sheets in Calc. These improvements should be noticeable, especially when working with complex documents. A new application-wide "Viewer mode" has also been implemented, which opens all files in a read-only state for quick, safe viewing. On a related note, The Document Foundation has joined efforts by the likes of KDE to encourage Windows 10 users to switch to Linux. Also, you might have heard that Denmark, in a bid to lessen its reliance on Microsoft, has decided to make a full switch to LibreOffice, with plans to begin phasing out Office 365 in certain ministries as early as next month. If you're interested in this release, you can read the full release notes and download the binaries for your platform: Windows, macOS (Intel | Apple Silicon), or Linux (DEB | RPM). You can also get the latest stable version from our software stories page. -
By Obi-Wan Kenobi · Posted
Is this a joke? -
By Lamp0 · Posted
FINALLY! Theyve fixed the context m— ….oh -
By The Werewolf · Posted
Until it can be used 100% offline (ie: PST file support or equiv) not even considering it. I'll jump to Thunderbird first which has gotten a LOT better since the last time I looked at it.
-
-
Recent Achievements
-
Case_f went up a rank
Explorer
-
Jamie Smith earned a badge
Conversation Starter
-
NeoToad777 earned a badge
First Post
-
JoeV earned a badge
Week One Done
-
VAT Services in UAE earned a badge
One Month Later
-
-
Popular Contributors
-
Tell a friend
Question
$phinX
Ive got a long stored proc that adds several strings to a varchar variable at different steps then outputs the full varchar result at the end.
Its adding the first 2 strings to the varchar, but it only adds half of the 3rd one and none of the 4th one.
I thought maybe the varchar variable was full... but ive set it to VARCHAR(8000) and when i do a LEN() on the final varchar variabl its only 269.
Anyone know why its cutting off the end of my varchar!?!?
(Using SQL Server 2000 btw)
Link to comment
https://www.neowin.net/forum/topic/319106-sql-varchar-cutting-off-my-string/Share on other sites
5 answers to this question
Recommended Posts